--[[
    编码: WMS-69-01
    名称: 清除和容器相关的所有数据对象
    作者：HAN  
    日期：2025-04-25

    级别：固定 (说明本段代码在项目中不太会变化)
    
    函数： ClearAll

    功能:
        注意这些脚本一般只用于在实施过程中，清理测试过程中的垃圾数据，不能用于正式环境
        清除所有容器和容器料格，并且编码从0001开始

    更改记录:

--]]

json  = require ("json")
mobox = require ("OILua_JavelinExt")
m3 = require("oi_base_mobox")

function ClearAll( strLuaDEID )
    local nRet, strRetInfo

    -- 把容器编码 FB- 开始的顺序号设置为 0001
    nRet, strRetInfo = mobox.removeSerialNumber( "容器", "FB-" )    
    if ( nRet ~= 0 )  then lua.Error( strLuaDEID, debug.getinfo(1), "removeSerialNumber() 失败! "..strRetInfo ) end 

    -- 把容器编码 ZB- 开始的顺序号设置为 0001
    nRet, strRetInfo = mobox.removeSerialNumber( "容器", "ZB-" )    
    if ( nRet ~= 0 )  then lua.Error( strLuaDEID, debug.getinfo(1), "removeSerialNumber() 失败! "..strRetInfo ) end 


    local strCondition = ""
    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Container")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Container】失败!"..strRetInfo) end

    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Container_Cell")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Container_Cell】失败!"..strRetInfo) end    

    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Container_Good")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Container_Good】失败!"..strRetInfo) end    

    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "CG_Detail")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【CG_Detail】失败!"..strRetInfo) end    

    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Loc_Container")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Loc_Container】失败!"..strRetInfo) end    

    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Lock")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Lock】失败!"..strRetInfo) end     
    
    -- 和配盘相关
    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Distribution_CNTR")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Distribution_CNTR】失败!"..strRetInfo) end    
    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Distribution_CNTR_Detail")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Distribution_CNTR_Detail】失败!"..strRetInfo) end     
    
    -- 和组盘相关
    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Pre_Alloc_Container")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Pre_Alloc_Container】失败!"..strRetInfo) end    
    nRet, strRetInfo = mobox.dbClearData(strLuaDEID, "Pre_Alloc_CNTR_Detail")
    if (nRet ~= 0) then lua.Error( strLuaDEID, debug.getinfo(1), "删除【Pre_Alloc_CNTR_Detail】失败!"..strRetInfo) end         

    local strUpdateSql = "N_CURRENT_NUM = 0, N_LOCK_STATE = 0, S_LOCK_OP = '', S_LOCK_STATE = ''"
    local strCondition = "S_WH_CODE = 'WH01'"
    nRet, strRetInfo = mobox.updateDataAttrByCondition( strLuaDEID, "Location", strCondition, strUpdateSql )
    if ( nRet ~= 0 ) then  lua.Error( strLuaDEID, debug.getinfo(1), "更新【货位】信息失败!"..strRetInfo ) end            
end